<html>
<head>
<title>console.sql</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
.s0 { color: #cc7832;}
.s1 { color: #a9b7c6;}
.s2 { color: #808080;}
.s3 { color: #6a8759;}
.s4 { color: #6897bb;}
.ln { color: #606366; font-weight: normal; font-style: normal; }
</style>
</head>
<body bgcolor="#2b2b2b">
<table CELLSPACING=0 CELLPADDING=5 COLS=1 WIDTH="100%" BGCOLOR="#606060" >
<tr><td><center>
<font face="Arial, Helvetica" color="#000000">
console.sql</font>
</center></td></tr></table>
<pre><a name="l1"><span class="ln">1    </span></a><span class="s0">create database </span><span class="s1">reclaim</span><span class="s0">;</span><span class="s2">#回收</span>
<a name="l2"><span class="ln">2    </span></a><span class="s0">use </span><span class="s1">reclaim</span><span class="s0">;</span>
<a name="l3"><span class="ln">3    </span></a>
<a name="l4"><span class="ln">4    </span></a><span class="s2">#user 部分</span>
<a name="l5"><span class="ln">5    </span></a><span class="s2">#select u.username username ,u.password password,u.phonenum phonenum,u.gender gender,u.nickname nickname,u.id id,u.birthday birthday,t.integral integral from t_integral t right join t_user u on u.id = t.userid</span>
<a name="l6"><span class="ln">6    </span></a><span class="s0">insert into </span><span class="s1">t_user </span><span class="s0">values </span><span class="s1">(</span><span class="s0">null,</span><span class="s3">'21111'</span><span class="s0">,</span><span class="s1">md5(</span><span class="s3">'123456'</span><span class="s1">)</span><span class="s0">,</span><span class="s3">'hhhhhhhh'</span><span class="s0">,</span><span class="s3">'男'</span><span class="s0">,date</span><span class="s1">(</span><span class="s3">'2001-07-10'</span><span class="s1">)</span><span class="s0">,</span><span class="s4">18044223232</span><span class="s0">,</span><span class="s4">100</span><span class="s1">)</span><span class="s0">;</span>
<a name="l7"><span class="ln">7    </span></a><span class="s2">#insert into t_user values (?,?,md5(?),?,?,date(?),?,?);</span>
<a name="l8"><span class="ln">8    </span></a>
<a name="l9"><span class="ln">9    </span></a><span class="s0">select </span><span class="s1">id</span><span class="s0">,</span><span class="s1">username</span><span class="s0">,password,</span><span class="s1">nickname</span><span class="s0">,</span><span class="s1">gender</span><span class="s0">,</span><span class="s1">birthday</span><span class="s0">,</span><span class="s1">phonenum</span><span class="s0">,</span><span class="s1">integral </span><span class="s0">from </span><span class="s1">t_user</span><span class="s0">;</span>
<a name="l10"><span class="ln">10   </span></a><span class="s0">select </span><span class="s1">u.id</span><span class="s0">,</span><span class="s1">u.username</span><span class="s0">,</span><span class="s1">u.password</span><span class="s0">,</span><span class="s1">u.nickname</span><span class="s0">,</span><span class="s1">u.gender</span><span class="s0">,</span><span class="s1">u.birthday</span><span class="s0">,</span><span class="s1">u.phonenum</span><span class="s0">,</span><span class="s1">i.integral </span><span class="s0">from </span><span class="s1">t_user u </span><span class="s0">left join </span><span class="s1">t_integral i </span><span class="s0">on </span><span class="s1">u.id = i.userid</span><span class="s0">;</span>
<a name="l11"><span class="ln">11   </span></a><span class="s2">#select u.id,u.username,u.password,u.nickname,u.gender,u.birthday,u.phonenum,i.integral from t_user u left join integral i on u.id = i.userid limit ?,?;</span>
<a name="l12"><span class="ln">12   </span></a><span class="s2">#select u.id,u.username,u.password,u.nickname,u.gender,u.birthday,u.phonenum,i.integral from t_user u left join integral i on u.id = i.userid where id =?;</span>
<a name="l13"><span class="ln">13   </span></a>
<a name="l14"><span class="ln">14   </span></a>
<a name="l15"><span class="ln">15   </span></a><span class="s0">delete from </span><span class="s1">t_user </span><span class="s0">where </span><span class="s1">id=</span><span class="s4">1</span><span class="s0">;</span>
<a name="l16"><span class="ln">16   </span></a><span class="s2">#delete from t_user where id=?;</span>
<a name="l17"><span class="ln">17   </span></a><span class="s0">update </span><span class="s1">t_user </span><span class="s0">set </span><span class="s1">phonenum=</span><span class="s4">17767678765 </span><span class="s0">where </span><span class="s1">id=</span><span class="s4">2</span><span class="s0">;</span>
<a name="l18"><span class="ln">18   </span></a><span class="s2">#update t_user set java拼接列名=? where id=?;     用户名不许修改在java中体现</span>
<a name="l19"><span class="ln">19   </span></a>
<a name="l20"><span class="ln">20   </span></a><span class="s2">#快递员</span>
<a name="l21"><span class="ln">21   </span></a><span class="s2"># select *from t_courier limit ?,?;</span>
<a name="l22"><span class="ln">22   </span></a><span class="s2"># select *from t_courier where id =?;</span>
<a name="l23"><span class="ln">23   </span></a>
<a name="l24"><span class="ln">24   </span></a><span class="s0">insert into </span><span class="s1">t_courier </span><span class="s0">values </span><span class="s1">(</span><span class="s0">null,</span><span class="s3">'1111111111111'</span><span class="s0">,</span><span class="s3">'空闲中'</span><span class="s0">,</span><span class="s4">12565777865</span><span class="s1">)</span><span class="s0">;</span>
<a name="l25"><span class="ln">25   </span></a><span class="s2">#insert into t_courier values (null,?,?,?);</span>
<a name="l26"><span class="ln">26   </span></a>
<a name="l27"><span class="ln">27   </span></a><span class="s0">delete from </span><span class="s1">t_courier </span><span class="s0">where </span><span class="s1">id=</span><span class="s4">1</span><span class="s0">;</span>
<a name="l28"><span class="ln">28   </span></a><span class="s2">#delete from t_courier where id=?;</span>
<a name="l29"><span class="ln">29   </span></a>
<a name="l30"><span class="ln">30   </span></a><span class="s0">update </span><span class="s1">t_courier </span><span class="s0">set </span><span class="s1">couriername=</span><span class="s3">'222'</span><span class="s0">,status</span><span class="s1">=</span><span class="s3">'配送中'</span><span class="s0">,</span><span class="s1">phonenum=</span><span class="s4">17767178765 </span><span class="s0">where </span><span class="s1">id=</span><span class="s4">2</span><span class="s0">;</span>
<a name="l31"><span class="ln">31   </span></a><span class="s2"># update t_courier set java拼接列名=? where id=?;       用户名不许修改在java中体现</span>
<a name="l32"><span class="ln">32   </span></a><span class="s2">#交易记录</span>
<a name="l33"><span class="ln">33   </span></a><span class="s0">select </span><span class="s1">t.id</span><span class="s0">,</span><span class="s1">t.ordername</span><span class="s0">,</span><span class="s1">u.username</span><span class="s0">,</span><span class="s1">c.couriername</span><span class="s0">,</span><span class="s1">createtime</span><span class="s0">,</span><span class="s1">finishtime </span><span class="s0">from </span><span class="s1">t_transaction t </span><span class="s0">left join </span><span class="s1">t_courier c </span><span class="s0">on </span><span class="s1">c.id = t.courierid </span><span class="s0">left join </span><span class="s1">t_user u </span><span class="s0">on </span><span class="s1">u.id = t.creareuserid</span><span class="s0">;</span>
<a name="l34"><span class="ln">34   </span></a><span class="s2">#select t.id,t.ordername,u.username,c.couriername,createtime,finishtime from t_transaction t left join courier c on c.id = t.courierid left join user u on u.id = t.creareuserid limit ?,?;</span>
<a name="l35"><span class="ln">35   </span></a><span class="s2">#select t.id,t.ordername,u.username,c.couriername,createtime,finishtime from t_transaction t left join courier c on c.id = t.courierid left join user u on u.id = t.creareuserid where id =?;</span>
<a name="l36"><span class="ln">36   </span></a>
<a name="l37"><span class="ln">37   </span></a><span class="s2">#物品</span>
<a name="l38"><span class="ln">38   </span></a><span class="s0">select </span><span class="s1">*</span><span class="s0">from </span><span class="s1">t_transaction</span>
<a name="l39"><span class="ln">39   </span></a><span class="s0">select </span><span class="s1">g.id</span><span class="s0">,</span><span class="s1">g.goodname</span><span class="s0">,</span><span class="s1">c.catename</span><span class="s0">,</span><span class="s1">g.price</span><span class="s0">,</span><span class="s1">u.username  </span><span class="s0">from </span><span class="s1">t_goods g </span><span class="s0">left join </span><span class="s1">t_user u </span><span class="s0">on </span><span class="s1">u.id = g.userid </span><span class="s0">left join </span><span class="s1">t_cate c </span><span class="s0">on </span><span class="s1">g.cateid = c.id</span><span class="s0">;</span>
<a name="l40"><span class="ln">40   </span></a><span class="s2"># select g.id,g.goodname,c.cataname,g.price,u.username username  from t_goods g left join user u on u.id = g.userid limit ?,?;</span>
<a name="l41"><span class="ln">41   </span></a><span class="s2"># select g.id,g.goodname,c.cataname,g.price,u.username username  from t_goods g left join user u on u.id = g.userid where id =?;</span>
<a name="l42"><span class="ln">42   </span></a><span class="s2">#insert into</span>
<a name="l43"><span class="ln">43   </span></a><span class="s0">insert into </span><span class="s1">t_goods </span><span class="s0">values </span><span class="s1">(</span><span class="s0">null,</span><span class="s3">'2222222222'</span><span class="s0">,</span><span class="s4">1</span><span class="s0">,</span><span class="s4">10.29</span><span class="s0">,</span><span class="s4">2</span><span class="s1">)</span><span class="s0">;</span>
<a name="l44"><span class="ln">44   </span></a><span class="s2"># insert into t_goods values (null,'111111111111111111','衣服',1111,2);</span>
<a name="l45"><span class="ln">45   </span></a><span class="s2"># insert into t_goods values (null,?,?,?,?);</span>
<a name="l46"><span class="ln">46   </span></a><span class="s2"># delete from t_goods where id =?;</span>
<a name="l47"><span class="ln">47   </span></a><span class="s0">update </span><span class="s1">t_goods </span><span class="s0">set </span><span class="s1">goodname=</span><span class="s3">'1111' </span><span class="s0">where </span><span class="s1">id=</span><span class="s4">1</span><span class="s0">;</span>
<a name="l48"><span class="ln">48   </span></a><span class="s2"># update t_goods set 拼接=? where id=?;</span>
<a name="l49"><span class="ln">49   </span></a>
<a name="l50"><span class="ln">50   </span></a><span class="s2">#活动</span>
<a name="l51"><span class="ln">51   </span></a><span class="s2"># select *from t_activity limit ?,?;</span>
<a name="l52"><span class="ln">52   </span></a><span class="s2"># select *from t_activity where id =?;</span>
<a name="l53"><span class="ln">53   </span></a><span class="s0">insert into </span><span class="s1">t_activity </span><span class="s0">values </span><span class="s1">(</span><span class="s0">null,</span><span class="s3">'11111'</span><span class="s0">,</span><span class="s3">'11111111111111111'</span><span class="s0">,DATE </span><span class="s1">(</span><span class="s3">'2011-09-08'</span><span class="s1">)</span><span class="s0">,</span><span class="s3">'进行中'</span><span class="s1">)</span><span class="s0">;</span>
<a name="l54"><span class="ln">54   </span></a><span class="s2"># insert into t_activity values (null,?,?,DATE (?),?);</span>
<a name="l55"><span class="ln">55   </span></a><span class="s2"># delete from t_activity where id =?</span>
<a name="l56"><span class="ln">56   </span></a><span class="s0">update </span><span class="s1">t_activity </span><span class="s0">set </span><span class="s1">title=</span><span class="s3">'222222' </span><span class="s0">where </span><span class="s1">id =</span><span class="s4">1</span><span class="s0">;</span>
<a name="l57"><span class="ln">57   </span></a><span class="s2"># update t_activity set 拼接=? where id =?;</span>
<a name="l58"><span class="ln">58   </span></a>
<a name="l59"><span class="ln">59   </span></a><span class="s2">#积分</span>
<a name="l60"><span class="ln">60   </span></a><span class="s2"># select i.id,u.username,i.integraltime,i.integral from t_integral i left join user u on u.id = i.userid limit ?,?;</span>
<a name="l61"><span class="ln">61   </span></a><span class="s0">select </span><span class="s1">i.id</span><span class="s0">,</span><span class="s1">u.username</span><span class="s0">,</span><span class="s1">i.integraltime</span><span class="s0">,</span><span class="s1">i.integral </span><span class="s0">from </span><span class="s1">t_integral i </span><span class="s0">left join </span><span class="s1">t_user u </span><span class="s0">on </span><span class="s1">u.id = i.userid</span><span class="s0">;</span>
<a name="l62"><span class="ln">62   </span></a><span class="s2"># select i.id,u.username,i.integraltime,i.integral from integral i left join user u on u.id = i.userid where id =?;</span>
<a name="l63"><span class="ln">63   </span></a><span class="s2"># update integral set 拼接=DATE (?) where id=?;</span>
<a name="l64"><span class="ln">64   </span></a>
<a name="l65"><span class="ln">65   </span></a><span class="s0">select </span><span class="s1">id</span><span class="s0">, </span><span class="s1">title</span><span class="s0">, </span><span class="s1">content</span><span class="s0">, </span><span class="s1">starttime</span><span class="s0">, </span><span class="s1">stat</span>
<a name="l66"><span class="ln">66   </span></a><span class="s0">from </span><span class="s1">t_activity</span><span class="s0">;</span>
<a name="l67"><span class="ln">67   </span></a><span class="s0">select </span><span class="s1">id</span><span class="s0">, </span><span class="s1">goodname</span><span class="s0">, </span><span class="s1">cateid</span><span class="s0">, </span><span class="s1">price</span><span class="s0">, </span><span class="s1">userid</span>
<a name="l68"><span class="ln">68   </span></a><span class="s0">from </span><span class="s1">t_goods</span><span class="s0">;</span>
<a name="l69"><span class="ln">69   </span></a><span class="s0">select </span><span class="s1">id</span><span class="s0">, </span><span class="s1">couriername</span><span class="s0">, status, </span><span class="s1">phonenum</span>
<a name="l70"><span class="ln">70   </span></a><span class="s0">from </span><span class="s1">t_courier</span><span class="s0">;</span>
<a name="l71"><span class="ln">71   </span></a>
<a name="l72"><span class="ln">72   </span></a><span class="s0">select </span><span class="s1">id</span><span class="s0">, </span><span class="s1">userid</span><span class="s0">, </span><span class="s1">integraltime</span><span class="s0">, </span><span class="s1">integral</span>
<a name="l73"><span class="ln">73   </span></a><span class="s0">from </span><span class="s1">t_integral</span><span class="s0">;</span>
<a name="l74"><span class="ln">74   </span></a><span class="s0">select </span><span class="s1">id</span><span class="s0">, </span><span class="s1">ordername</span><span class="s0">, </span><span class="s1">creareuserid</span><span class="s0">, </span><span class="s1">courierid</span><span class="s0">, </span><span class="s1">createtime</span><span class="s0">, </span><span class="s1">finishtime</span>
<a name="l75"><span class="ln">75   </span></a><span class="s0">from </span><span class="s1">t_transaction</span><span class="s0">;</span>
<a name="l76"><span class="ln">76   </span></a>
<a name="l77"><span class="ln">77   </span></a><span class="s0">insert into </span><span class="s1">t_admin </span><span class="s0">values </span><span class="s1">(</span><span class="s0">null,</span><span class="s1">md5(</span><span class="s3">'1'</span><span class="s1">)</span><span class="s0">,</span><span class="s3">'a'</span><span class="s0">,</span><span class="s3">'b'</span><span class="s1">)</span><span class="s0">;</span>
<a name="l78"><span class="ln">78   </span></a>
<a name="l79"><span class="ln">79   </span></a><span class="s0">select </span><span class="s1">*</span><span class="s0">from </span><span class="s1">t_admin </span><span class="s0">where </span><span class="s1">loginname= </span><span class="s3">'admin' </span><span class="s0">and password</span><span class="s1">=md5(</span><span class="s3">'123456'</span><span class="s1">)</span><span class="s0">;</span>
<a name="l80"><span class="ln">80   </span></a>
<a name="l81"><span class="ln">81   </span></a><span class="s0">select </span><span class="s1">u.id</span><span class="s0">,</span><span class="s1">u.username</span><span class="s0">,</span><span class="s1">u.password</span><span class="s0">,</span><span class="s1">u.nickname</span><span class="s0">,</span><span class="s1">u.gender</span><span class="s0">,</span><span class="s1">u.birthday</span><span class="s0">,</span><span class="s1">u.phonenum</span><span class="s0">,</span><span class="s1">i.integral </span><span class="s0">from </span><span class="s1">t_user u </span><span class="s0">left join </span><span class="s1">t_integral i </span><span class="s0">on </span><span class="s1">u.id = i.userid </span><span class="s0">limit </span><span class="s4">0</span><span class="s0">,</span><span class="s4">2</span><span class="s0">;</span>
<a name="l82"><span class="ln">82   </span></a>
<a name="l83"><span class="ln">83   </span></a><span class="s0">select count</span><span class="s1">(*) totalSize </span><span class="s0">from </span><span class="s1">t_user</span><span class="s0">;</span>
<a name="l84"><span class="ln">84   </span></a>
<a name="l85"><span class="ln">85   </span></a>
<a name="l86"><span class="ln">86   </span></a><span class="s2">#id,username,password,nickname,gender,birthday,phonenum</span>
<a name="l87"><span class="ln">87   </span></a>
<a name="l88"><span class="ln">88   </span></a><span class="s0">update </span><span class="s1">t_user </span><span class="s0">set </span><span class="s1">username=</span><span class="s3">'hhhh'</span><span class="s0">,password</span><span class="s1">=md5(</span><span class="s4">111111</span><span class="s1">)</span><span class="s0">,</span><span class="s1">nickname=</span><span class="s3">'qqqqq'</span><span class="s0">,</span><span class="s1">gender=</span><span class="s3">'女'</span><span class="s0">,</span><span class="s1">birthday=now()</span><span class="s0">,</span><span class="s1">phonenum=</span><span class="s4">16754208642 </span><span class="s0">where </span><span class="s1">id=</span><span class="s4">2</span><span class="s0">;</span>
<a name="l89"><span class="ln">89   </span></a>
<a name="l90"><span class="ln">90   </span></a>
<a name="l91"><span class="ln">91   </span></a><span class="s2">#select t.id id,t.ordername ordername,u.username creareusername,c.couriername couriername,t.createtime createtime,t.finishtime finishtime from t_transaction t left join (select username,id uid from t_user union all select couriername,id cid from t_courier) tcu  on (tcu.uid=t.creareuserid and tcu.cid=t.courierid)#t_courier c on c.id = t.courierid left join t_user u on u.id = t.creareuserid</span>
<a name="l92"><span class="ln">92   </span></a>
<a name="l93"><span class="ln">93   </span></a>
<a name="l94"><span class="ln">94   </span></a>
<a name="l95"><span class="ln">95   </span></a>
<a name="l96"><span class="ln">96   </span></a>
<a name="l97"><span class="ln">97   </span></a><span class="s2">#create view v_u_c as</span>
<a name="l98"><span class="ln">98   </span></a>
<a name="l99"><span class="ln">99   </span></a>
<a name="l100"><span class="ln">100  </span></a>
<a name="l101"><span class="ln">101  </span></a>
<a name="l102"><span class="ln">102  </span></a>
<a name="l103"><span class="ln">103  </span></a>
<a name="l104"><span class="ln">104  </span></a>
<a name="l105"><span class="ln">105  </span></a>
<a name="l106"><span class="ln">106  </span></a><span class="s0">select </span><span class="s1">t.id</span><span class="s0">,</span><span class="s1">t.ordername</span><span class="s0">,</span><span class="s1">u.username creareusername</span><span class="s0">,</span><span class="s1">c.couriername</span><span class="s0">,</span><span class="s1">createtime</span><span class="s0">,</span><span class="s1">finishtime </span><span class="s0">from </span><span class="s1">t_transaction t</span><span class="s0">,</span><span class="s1">t_user u</span><span class="s0">,</span><span class="s1">t_courier c</span><span class="s2"># left join t_courier c on c.id = t.courierid #left join t_user u on u.id = t.creareuserid limit 0,1;</span>
<a name="l107"><span class="ln">107  </span></a>
<a name="l108"><span class="ln">108  </span></a><span class="s0">;</span>
<a name="l109"><span class="ln">109  </span></a><span class="s0">select </span><span class="s1">id </span><span class="s0">from </span><span class="s1">t_cate </span><span class="s0">where </span><span class="s1">catename=</span><span class="s3">'衣物'</span><span class="s0">;</span>
<a name="l110"><span class="ln">110  </span></a>
<a name="l111"><span class="ln">111  </span></a><span class="s2"># select *from t_cate;</span>
<a name="l112"><span class="ln">112  </span></a><span class="s2"># select *from t_user</span>
<a name="l113"><span class="ln">113  </span></a>
<a name="l114"><span class="ln">114  </span></a>
<a name="l115"><span class="ln">115  </span></a>
<a name="l116"><span class="ln">116  </span></a>
<a name="l117"><span class="ln">117  </span></a>
<a name="l118"><span class="ln">118  </span></a>
<a name="l119"><span class="ln">119  </span></a>
<a name="l120"><span class="ln">120  </span></a>
<a name="l121"><span class="ln">121  </span></a><span class="s0">select </span><span class="s1">id</span><span class="s0">, </span><span class="s1">goodname</span><span class="s0">, </span><span class="s1">cateid</span><span class="s0">, </span><span class="s1">price</span><span class="s0">, </span><span class="s1">userid</span>
<a name="l122"><span class="ln">122  </span></a><span class="s0">from </span><span class="s1">t_goods</span><span class="s0">;</span>
<a name="l123"><span class="ln">123  </span></a>
<a name="l124"><span class="ln">124  </span></a><span class="s0">update </span><span class="s1">t_goods </span><span class="s0">set </span><span class="s1">goodname=</span><span class="s3">'111'</span><span class="s0">,</span><span class="s1">cateid=</span><span class="s4">1</span><span class="s0">,</span><span class="s1">price=</span><span class="s4">222.22</span><span class="s0">,</span><span class="s1">userid=</span><span class="s4">2 </span><span class="s0">where </span><span class="s1">id=</span><span class="s4">1</span><span class="s0">;</span>
<a name="l125"><span class="ln">125  </span></a>
<a name="l126"><span class="ln">126  </span></a>
<a name="l127"><span class="ln">127  </span></a>
<a name="l128"><span class="ln">128  </span></a>
<a name="l129"><span class="ln">129  </span></a>
<a name="l130"><span class="ln">130  </span></a><span class="s0">select </span><span class="s1">id</span><span class="s0">, </span><span class="s1">title</span><span class="s0">, </span><span class="s1">content</span><span class="s0">, </span><span class="s1">starttime</span><span class="s0">, </span><span class="s1">stat</span>
<a name="l131"><span class="ln">131  </span></a><span class="s0">from </span><span class="s1">t_activity</span><span class="s0">;</span>
<a name="l132"><span class="ln">132  </span></a>
<a name="l133"><span class="ln">133  </span></a>
<a name="l134"><span class="ln">134  </span></a>
<a name="l135"><span class="ln">135  </span></a><span class="s0">insert into </span><span class="s1">t_activity </span><span class="s0">values </span><span class="s1">(</span><span class="s0">null,</span><span class="s3">'1111111111111111'</span><span class="s0">,</span><span class="s3">'222222222222222'</span><span class="s0">,</span><span class="s1">)</span>
<a name="l136"><span class="ln">136  </span></a>
<a name="l137"><span class="ln">137  </span></a>
<a name="l138"><span class="ln">138  </span></a>
<a name="l139"><span class="ln">139  </span></a><span class="s0">;</span>
<a name="l140"><span class="ln">140  </span></a><span class="s0">update </span><span class="s1">t_activity </span><span class="s0">set </span><span class="s1">title=</span><span class="s3">'wwwww'</span><span class="s0">,</span><span class="s1">content=</span><span class="s3">'11'</span><span class="s0">,</span><span class="s1">starttime=</span><span class="s0">DATE</span><span class="s1">(</span><span class="s3">'2019-09-08'</span><span class="s1">)</span><span class="s0">,</span><span class="s1">stat=</span><span class="s3">'进行中' </span><span class="s0">where </span><span class="s1">id=</span><span class="s4">1</span><span class="s0">;</span>
<a name="l141"><span class="ln">141  </span></a>
<a name="l142"><span class="ln">142  </span></a>
<a name="l143"><span class="ln">143  </span></a><span class="s0">update </span><span class="s1">t_user </span><span class="s0">set </span><span class="s1">integral=</span><span class="s4">111111 </span><span class="s0">where </span><span class="s1">id=</span><span class="s4">2</span><span class="s0">;</span>
<a name="l144"><span class="ln">144  </span></a>
<a name="l145"><span class="ln">145  </span></a><span class="s0">select </span><span class="s1">id</span><span class="s0">,</span><span class="s1">username</span><span class="s0">,</span><span class="s1">integraltime</span><span class="s0">,</span><span class="s1">integral </span><span class="s0">from </span><span class="s1">t_user</span><span class="s0">;</span></pre>
</body>
</html>